/*
Navicat SQL Server Data Transfer

Source Server         : 192.168.1.124
Source Server Version : 100000
Source Host           : 192.168.1.124:1433
Source Database       : CUNITSystem
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 100000
File Encoding         : 65001

Date: 2014-01-21 16:54:04
*/


-- ----------------------------
-- Table structure for [T_CB_GRADE]
-- ----------------------------
DROP TABLE [T_CB_GRADE]
GO
CREATE TABLE [T_CB_GRADE] (
[gradeId] int NOT NULL IDENTITY(1,1) ,
[GradeName] varchar(100) NULL ,
[createTime] datetime NULL 
)


GO
DBCC CHECKIDENT(N'[T_CB_GRADE]', RESEED, 5)
GO

-- ----------------------------
-- Records of T_CB_GRADE
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [T_CB_GRADE] ON
GO
INSERT INTO [T_CB_GRADE] ([gradeId], [GradeName], [createTime]) VALUES (N'1', N'大学1年级', N'2014-01-21 11:47:27.000');
INSERT INTO [T_CB_GRADE] ([gradeId], [GradeName], [createTime]) VALUES (N'2', N'大学2年级', N'2014-01-21 11:47:30.000');
INSERT INTO [T_CB_GRADE] ([gradeId], [GradeName], [createTime]) VALUES (N'3', N'大学3年级', N'2014-01-21 11:47:32.000');
INSERT INTO [T_CB_GRADE] ([gradeId], [GradeName], [createTime]) VALUES (N'4', N'大学4年级', N'2014-01-21 11:47:35.000');
INSERT INTO [T_CB_GRADE] ([gradeId], [GradeName], [createTime]) VALUES (N'5', N'大学5年级', N'2014-01-21 11:47:37.000');
GO
SET IDENTITY_INSERT [T_CB_GRADE] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for [T_CB_MENUS]
-- ----------------------------
DROP TABLE [T_CB_MENUS]
GO
CREATE TABLE [T_CB_MENUS] (
[MenuId] int NOT NULL IDENTITY(1,1) ,
[ParentMenuId] int NOT NULL ,
[MenuName] varchar(50) NOT NULL ,
[CreateTime] datetime NOT NULL ,
[MenuURL] varchar(100) NULL ,
[OrderNum] int NULL ,
[MenuType] int NOT NULL 
)


GO
DBCC CHECKIDENT(N'[T_CB_MENUS]', RESEED, 44)
GO

-- ----------------------------
-- Records of T_CB_MENUS
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [T_CB_MENUS] ON
GO
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'1', N'0', N'我的课程', N'2014-01-06 14:37:32.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'2', N'0', N'我的资源', N'2014-01-06 14:37:56.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'3', N'0', N'网络课程', N'2014-01-06 15:53:54.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'4', N'1', N'在修课程', N'2014-01-06 15:55:10.000', N'', null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'5', N'3', N'课程列表', N'2014-01-06 16:18:44.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'6', N'0', N'资源管理', N'2014-01-06 17:52:50.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'7', N'0', N'学生管理', N'2014-01-06 17:53:24.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'13', N'6', N'资源列表', N'2014-01-06 17:56:16.000', N'/manager/resourceList.jsp', null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'14', N'0', N'网络课程', N'2014-01-06 17:56:34.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'15', N'0', N'教师管理', N'2014-01-06 17:58:00.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'16', N'0', N'题库管理', N'2014-01-06 17:58:16.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'17', N'0', N'推荐管理', N'2014-01-06 17:58:39.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'18', N'17', N'推荐教学材料', N'2014-01-06 18:00:16.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'19', N'17', N'推荐教学课程', N'2014-01-06 18:00:39.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'20', N'17', N'推荐教学方法', N'2014-01-06 18:01:01.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'21', N'17', N'推荐教学目标', N'2014-01-06 18:01:21.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'22', N'16', N'试题列表', N'2014-01-06 18:02:08.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'23', N'15', N'教师列表', N'2014-01-06 18:02:32.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'24', N'14', N'科目列表', N'2014-01-06 18:02:54.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'25', N'7', N'学生列表', N'2014-01-06 18:03:34.000', N'/manager/studentList.jsp', null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'26', N'16', N'选项列表', N'2014-01-07 10:36:09.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'27', N'7', N'年级列表', N'2014-01-07 10:37:41.000', null, null, N'1');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'28', N'1', N'已修完课程', N'2014-01-07 10:58:39.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'29', N'2', N'音频视频', N'2014-01-07 11:02:18.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'30', N'2', N'文献资料', N'2014-01-07 11:03:32.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'31', N'0', N'在线求助', N'2014-01-07 11:09:42.000', null, null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'33', N'31', N'求助老师', N'2014-01-07 11:13:41.000', N'/client/helpTeacher.jsp', null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'34', N'31', N'讨论组', N'2014-01-07 11:15:12.000', N'/client/discussion.jsp', null, N'2');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'35', N'0', N'我的课程', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'36', N'0', N'我的资源', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'37', N'0', N'在线解答', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'38', N'37', N'回答问题', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'39', N'37', N'讨论组', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'40', N'35', N'课程列表', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'41', N'36', N'推荐教学材料', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'42', N'36', N'推荐教学课程', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'43', N'36', N'推荐教学方法', N'2014-01-06 14:37:32.000', N'', null, N'3');
INSERT INTO [T_CB_MENUS] ([MenuId], [ParentMenuId], [MenuName], [CreateTime], [MenuURL], [OrderNum], [MenuType]) VALUES (N'44', N'36', N'推荐教学目标', N'2014-01-06 14:37:32.000', N'', null, N'3');
GO
SET IDENTITY_INSERT [T_CB_MENUS] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for [T_CB_NETWORKCOURSE]
-- ----------------------------
DROP TABLE [T_CB_NETWORKCOURSE]
GO
CREATE TABLE [T_CB_NETWORKCOURSE] (
[nwId] int NOT NULL ,
[CourseName] varchar(100) NULL ,
[gradeId] int NULL ,
[createTime] time(7) NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CB_NETWORKCOURSE', 
'COLUMN', N'gradeId')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'1 音频视频 
   2 教学素材
   3 教学课件
   4 教学文献'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CB_NETWORKCOURSE'
, @level2type = 'COLUMN', @level2name = N'gradeId'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'1 音频视频 
   2 教学素材
   3 教学课件
   4 教学文献'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CB_NETWORKCOURSE'
, @level2type = 'COLUMN', @level2name = N'gradeId'
GO

-- ----------------------------
-- Records of T_CB_NETWORKCOURSE
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for [T_CB_RESOURCE]
-- ----------------------------
DROP TABLE [T_CB_RESOURCE]
GO
CREATE TABLE [T_CB_RESOURCE] (
[resourceID] int NOT NULL IDENTITY(1,1) ,
[resourceName] varchar(200) NULL ,
[resourcePath] varchar(1000) NULL ,
[resourceType] int NULL ,
[createTime] datetime NULL 
)


GO
DBCC CHECKIDENT(N'[T_CB_RESOURCE]', RESEED, 46)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CB_RESOURCE', 
'COLUMN', N'resourceType')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'1 音频视频 
   2 教学素材
   3 教学课件
   4 教学文献'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CB_RESOURCE'
, @level2type = 'COLUMN', @level2name = N'resourceType'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'1 音频视频 
   2 教学素材
   3 教学课件
   4 教学文献'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CB_RESOURCE'
, @level2type = 'COLUMN', @level2name = N'resourceType'
GO

-- ----------------------------
-- Records of T_CB_RESOURCE
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [T_CB_RESOURCE] ON
GO
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'1', N'大学语文', N'c:/大学语文.avi', N'1', N'2014-01-15 14:04:30.000');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'2', N'sdf', N'dnf.txt', N'1', N'2014-01-15 17:43:18.930');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'3', N'asdf', N'dnf.txt', N'1', N'2014-01-15 17:44:51.653');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'4', N'fvgcfbvc', N'dnf.txt', N'1', N'2014-01-15 17:47:48.200');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'8', N'sdfa', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 11:20:19.653');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'9', N'sdfa', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 11:21:12.770');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'10', N'fgfhghg', N'c8177f3e6709c93de82f1e869e3df8dcd00054e5.gif', N'1', N'2014-01-16 11:22:16.340');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'11', N'sdafffcv', N'c8177f3e6709c93de82f1e869e3df8dcd00054e5.gif', N'1', N'2014-01-16 11:22:53.250');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'12', N'vxcbvnb', N'main_10.JPG', N'1', N'2014-01-16 11:32:49.187');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'13', N'sdfsdfcvb v ', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 11:46:25.670');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'14', N'sdfacvcb', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 11:47:26.300');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'15', N'vbnblp', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 11:47:53.483');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'16', N'uyoim', N'c8177f3e6709c93de82f1e869e3df8dcd00054e5.gif', N'1', N'2014-01-16 11:49:08.437');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'17', N'234brtyuqwq', N'myeclipse配置.txt', N'1', N'2014-01-16 11:51:09.937');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'18', N'b768678', N'c8177f3e6709c93de82f1e869e3df8dcd00054e5.gif', N'1', N'2014-01-16 11:59:03.250');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'19', N'123s455523', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 12:00:20.530');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'20', N'575', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 13:38:23.903');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'21', N'dsf', N'非常规类型换话费业务.txt', N'1', N'2014-01-16 13:39:39.983');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'22', N'5644', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 13:40:15.263');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'23', N'8768678', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 13:45:46.530');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'24', N'sdfa', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:22:11.187');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'25', N'sdfbvb', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:26:23.763');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'26', N'1', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:26:59.687');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'27', N'2355', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:27:43.640');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'28', N'sdf1231', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:31:50.403');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'29', N'456456', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:33:35.467');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'30', N'67000', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:35:55.263');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'31', N'456799', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:39:26.900');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'32', N'2', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:43:59.340');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'33', N'23123', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:49:24.920');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'34', N'23dd5', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-16 14:50:30.937');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'42', N'1231cv', N'codetemplates_CloudReal_v1.0.xml', N'2', N'2014-01-17 17:40:17.327');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'43', N'777777', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-21 16:30:14.413');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'44', N'1111', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-21 16:32:20.930');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'45', N'777777777', N'codetemplates_CloudReal_v1.0.xml', N'1', N'2014-01-21 16:32:32.787');
INSERT INTO [T_CB_RESOURCE] ([resourceID], [resourceName], [resourcePath], [resourceType], [createTime]) VALUES (N'46', N'1231231231', N'codetemplates_CloudReal_v1.0.xml', N'2', N'2014-01-21 16:32:41.210');
GO
SET IDENTITY_INSERT [T_CB_RESOURCE] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for [T_CB_STUDENT]
-- ----------------------------
DROP TABLE [T_CB_STUDENT]
GO
CREATE TABLE [T_CB_STUDENT] (
[sid] int NOT NULL IDENTITY(1,1) ,
[sName] varchar(50) NULL ,
[sex] char(1) NULL ,
[age] int NULL ,
[email] varchar(100) NULL ,
[phone] char(11) NULL ,
[address] varchar(1000) NULL ,
[sNo] char(18) NULL ,
[createTime] datetime NULL ,
[gradeId] int NULL 
)


GO
DBCC CHECKIDENT(N'[T_CB_STUDENT]', RESEED, 11)
GO

-- ----------------------------
-- Records of T_CB_STUDENT
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [T_CB_STUDENT] ON
GO
INSERT INTO [T_CB_STUDENT] ([sid], [sName], [sex], [age], [email], [phone], [address], [sNo], [createTime], [gradeId]) VALUES (N'6', N'张三', N'1', N'21', N'zhangsan@163.com', N'12345678912', N'中国北京', N'123456789123456789', N'2014-01-21 11:50:38.000', N'1');
INSERT INTO [T_CB_STUDENT] ([sid], [sName], [sex], [age], [email], [phone], [address], [sNo], [createTime], [gradeId]) VALUES (N'7', N'李四', N'1', N'23', N'lisi@163.com', N'12345678912', N'中国上海', N'123456789123456789', N'2014-01-21 15:28:22.000', N'2');
INSERT INTO [T_CB_STUDENT] ([sid], [sName], [sex], [age], [email], [phone], [address], [sNo], [createTime], [gradeId]) VALUES (N'8', N'王五', N'2', N'22', N'wangwu@163.com', N'12345678912', N'中国天津', N'123456789123456789', N'2014-01-21 15:32:24.803', N'3');
GO
SET IDENTITY_INSERT [T_CB_STUDENT] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for [T_CB_USERINFO]
-- ----------------------------
DROP TABLE [T_CB_USERINFO]
GO
CREATE TABLE [T_CB_USERINFO] (
[userId] int NOT NULL IDENTITY(1,1) ,
[loginName] varchar(32) NOT NULL ,
[loginPwd] varchar(32) NOT NULL ,
[fkId] int NULL ,
[userType] int NOT NULL 
)


GO
DBCC CHECKIDENT(N'[T_CB_USERINFO]', RESEED, 4)
GO

-- ----------------------------
-- Records of T_CB_USERINFO
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [T_CB_USERINFO] ON
GO
INSERT INTO [T_CB_USERINFO] ([userId], [loginName], [loginPwd], [fkId], [userType]) VALUES (N'1', N'admin', N'123456', null, N'1');
INSERT INTO [T_CB_USERINFO] ([userId], [loginName], [loginPwd], [fkId], [userType]) VALUES (N'2', N'zhangsan', N'123456', null, N'2');
INSERT INTO [T_CB_USERINFO] ([userId], [loginName], [loginPwd], [fkId], [userType]) VALUES (N'3', N'lisi', N'123456', null, N'3');
INSERT INTO [T_CB_USERINFO] ([userId], [loginName], [loginPwd], [fkId], [userType]) VALUES (N'4', N'wangwu', N'123456', null, N'3');
GO
SET IDENTITY_INSERT [T_CB_USERINFO] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Indexes structure for table T_CB_GRADE
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_GRADE]
-- ----------------------------
ALTER TABLE [T_CB_GRADE] ADD PRIMARY KEY ([gradeId])
GO

-- ----------------------------
-- Indexes structure for table T_CB_MENUS
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_MENUS]
-- ----------------------------
ALTER TABLE [T_CB_MENUS] ADD PRIMARY KEY ([MenuId])
GO

-- ----------------------------
-- Indexes structure for table T_CB_NETWORKCOURSE
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_NETWORKCOURSE]
-- ----------------------------
ALTER TABLE [T_CB_NETWORKCOURSE] ADD PRIMARY KEY ([nwId])
GO

-- ----------------------------
-- Indexes structure for table T_CB_RESOURCE
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_RESOURCE]
-- ----------------------------
ALTER TABLE [T_CB_RESOURCE] ADD PRIMARY KEY ([resourceID])
GO

-- ----------------------------
-- Indexes structure for table T_CB_STUDENT
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_STUDENT]
-- ----------------------------
ALTER TABLE [T_CB_STUDENT] ADD PRIMARY KEY ([sid])
GO

-- ----------------------------
-- Indexes structure for table T_CB_USERINFO
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [T_CB_USERINFO]
-- ----------------------------
ALTER TABLE [T_CB_USERINFO] ADD PRIMARY KEY ([userId])
GO

-- ----------------------------
-- Foreign Key structure for table [T_CB_NETWORKCOURSE]
-- ----------------------------
ALTER TABLE [T_CB_NETWORKCOURSE] ADD FOREIGN KEY ([gradeId]) REFERENCES [T_CB_GRADE] ([gradeId]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Key structure for table [T_CB_STUDENT]
-- ----------------------------
ALTER TABLE [T_CB_STUDENT] ADD FOREIGN KEY ([gradeId]) REFERENCES [T_CB_GRADE] ([gradeId]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
